Research on Method of Export Data into Excel in C#.NET

doi:10.3969/j.issn.1006-2475.2011.04.009

Computer and Modernization ›› 2011, Vol. 1 ›› Issue (4): 29-31.doi: 10.3969/j.issn.1006-2475.2011.04.009

• 数据库 • Previous Articles Next Articles

Research on Method of Export Data into Excel in C#.NET

SU Qing, LI Zhong-liang, WU Wei-min

Visualization in Scientific Computing Laboratory, Faculty of Computer, Guangdong University of Technology, Guangzhou 510006, China

Received:2010-12-07 Revised:1900-01-01 Online:2011-04-27 Published:2011-04-27

Abstract

Abstract: In C# .NET, the commonly method of export the data in the component of DataGridView into Excel uses the Excel’s COM component to achieve it. But because the vision of Excel between the development machine and user’s machine installed maybe different, this method often leads to the phenomenon of incompatible. To solve this problem, the reflection technique is proposed to implement the interaction of C# and Excel. Through the experiment on the computer with different visions of Excel, the results show that this method can solve the problem of version compatibility very well. 

Key words: reflection, COM component, Excel

CLC Number:

TP311.131

SU Qing;LI Zhong-liang;WU Wei-min. Research on Method of Export Data into Excel in C#.NET[J]. Computer and Modernization, 2011, 1(4): 29-31.

[1]	WANG Zheng-min, ZHANG Tai-hong, LI Yong-ke, BAI Tao. FreeMarker Template Engine Online Dynamically Generating Excel and Word Files Technology [J]. Computer and Modernization, 2016, 0(4): 109-113.
[2]	JI Kai-wei, LE Hong-bing. Research and Application of Rule Engine on Access Control [J]. Computer and Modernization, 2015, 0(8): 75-79.
[3]	WANG Xuying, YAN Chong. Monte Carlo Simulation Based on Cloud Computing [J]. Computer and Modernization, 2014, 0(4): 168-171.
[4]	TANG Yan, HAN Ai-qing, ZHAI Xing. Survey Data Read Automatically by Using VBA [J]. Computer and Modernization, 2014, 0(2): 226-228+234.
[5]	GUO Xin1,2, ZHANG Jian-wei 1,2, XIAO Chao1,2. A Way to Prevent Optical Interference of Multi-projector Display System [J]. Computer and Modernization, 2014, 0(11): 53-56.
[6]	ZHANG Zheng;. Design and Implementation of Auto-filled Bulk Web Forms System [J]. Computer and Modernization, 2013, 1(2): 169-172.
[7]	YOU Su-nan. Application of Excel Form in Fast Plotting Exploratory Points by Category in CAD [J]. Computer and Modernization, 2013, 1(2): 163-168+.
[8]	HAO Han-han, KANG Mu-ning . Design and Implementation of Automatic Problem Building System on Excel Operation Test [J]. Computer and Modernization, 2013, 12(12): 201-205.
[9]	HAN Ai-qing;XUE Lei;SHEN Jun-hui;GUO Feng-ying;TANG Yan. Random Producing Test Paper Algorithm with Multi-parameters Constraint Based on Data Dictionary [J]. Computer and Modernization, 2013, 218(10): 16-18.
[10]	DENG Chao-hui. Design and Implementation of Setting up Position for Institutional  Organization Scoring System Based on Excel VBA [J]. Computer and Modernization, 2012, 1(10): 213-215.
[11]	LI Hua;ZHANG Wei-na. Design of Automatic Grading System for Standardized Examination Papers by Excel [J]. Computer and Modernization, 2012, 1(1): 199-202,.
[12]	LI Aifeng;HU Songling. Online Score Query System Based on Excel [J]. Computer and Modernization, 2012, 8(08): 163-165.
[13]	DU Shi-yu;WANG Zi-yuan. Application Research on Excel in VC++ Environment [J]. Computer and Modernization, 2011, 1(8): 201-203,.
[14]	LIU Rui-tong;GOU Xian-tai;MA Chao;ZHANG Jian-feng. Methods of Access Excel Based on BasicExcel [J]. Computer and Modernization, 2011, 1(8): 198-200.
[15]	HUANG Jun;LIU Xiao-ping;XU Shao-ping;. Research Progress on Welding Simulation Systems [J]. Computer and Modernization, 2011, 1(6): 40-5.

Research on Method of Export Data into Excel in C#.NET

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics

Comments